008 sql server studio part 2

现在我们已经重新启动了计算机,我们已经安装了续集 Management Studio。
Now that we've restarted our computer we've got our sequel Management Studio installed.

现在我们实际上需要安装我们的续集服务器,所以我将右键单击它,并且我还将以管理员身份运行它,是的,我将采用我的默认位置,它看起来像是另一个快速提取。
Now we actually need to install our sequel server so I'm going to right click on that and I'm going to also run that as an administrator Yes and I'll take my default location and it looks like another quick extraction.

续集的服务器有多个版本。
There are several versions of sequel's server.

Express 版本是免费的,允许您创建高达 10 GB 的数据库,这对我们来说绰绰有余。
The Express version is free and that allows you to create databases up to 10 gigabytes which is way more than enough for us.

所以我们将在这方面一路自由。
So we will be going free all the way on this.

好的。
All right.

这看起来应该很熟悉。
And this should look pretty familiar.

因此,我们将继续并再次单击第一个选项,并采用新的续集服务器独立安装或向现有安装添加功能。
So we're just going to go ahead and click on the first option once again and take that new sequel server standalone installation or add features to an existing installation.

在这种情况下,我们将添加功能,因为我们已经安装了管理工作室和工具。
In this case we're going to be adding features because we've already got our management studio and our tools installed.

现在我们只想将实际的服务器放在那里,以便我们有地方放置数据。
Now we just want to put the actual server in there so we have a place to put our data.

所以我会接受。
So I will accept.

我将采取下一步,并且不会使用 Microsoft Update。
I'll take next and I won't use Microsoft Update.

我将通过单击“下一步”跳过该内容。
I'll just skip past that by clicking next.

好吧,我们在这里保留默认选项。
All right we'll keep the default options here.

我们点击下一步。
Let's click next.

再次。
Again.

好吧,现在我们实际上要设置我们的服务器。
All right so now we're actually going to be setting up our server.

我将继续将其保留为续集 Express 命名实例,因此默认值一直是我们喜欢的默认值,它使事情变得美好而简单,我们也将在这个上采用默认值。
And I'm just going to go ahead and keep this as sequel Express named instance so default values all the way we like default values that keeps things nice and easy and we will take defaults on this one as well.

接下来我们将再看一个屏幕。
One more screen we'll take next.

现在我们正在进行安装,所以这应该需要几分钟,然后我们就完成了。
And now we're into our installation so this should take a couple of minutes and then we'll be done.

之后我们应该能够启动我们的管理工作室并实际连接到我们的续集的服务器。
And we should be able to launch our management studio after that and actually connect to our sequel's server OK.

就是这样。
That's it.

看起来我们已经安装了整个东西。
It looks like we've got this whole thing installed.

因此,让我们继续前进并关闭那里,让我们的管理工作室出现在我们面前。
So let's go ahead and close out of there and let's get our management studio in front of us.

所以我要回到这里。
So I'm going to come back into here.

Microsoft 续集服务器 2014,我将继续单击管理工作室。
Microsoft sequel server 2014 and I'm going to go ahead and click on the management studio.

这应该可以为我们加载。
And that should load right up for us.

现在我们要真正决定我们想要连接到什么。
And now we get to actually decide what we want to connect to.

因此,让我们进入 Brough 的数据库引擎,我们将把它作为一个桌面,然后点击连接,一旦我们中了大奖,我们就会看到数据库符号旁边有一个绿色的小图标。
So let's go into Brough's database engine and we're going to take this a desktop right here and hit connect and as soon as we do jack jackpot we see that we've got a little green icon next to that database symbol there.

除了我们的系统数据库之外,我们实际上没有任何数据库。
And we don't really have any data bases except our system data base.

但现在我们实际上可以通过这里创建一个数据库,甚至可以与其管理进行交互。
But now we could actually go through here and create a database and even interact with it management.

现在,这不是续集课程,这不是数据库课程,因此我们不会非常熟悉续集命令、查询、数据库管理和服务器管理。
Now this is not a sequel course this is not a database course so we are not going to be getting intimately familiar with sequel commands with queries with database management with server administration.

我们将使用它来进行数据记录数据采集。
What we are going to be using this for is data logging data acquisition.

因此,我们将在 PLCC 运行时将数据从 PLCC 中提取出来,并将其存储到我们的数据库中,然后我们将进行一些简单的检索以提取该数据并查看它。
So we are going to be pulling data out of our PLCC while it's running storing that into our database and then we'll do some simple retrievals to pull that data out and look at it.

但同样,这不是一个报告课程,因此我们不会讨论 Crystal Reports 和高级 Access 报告以及各种不同的基于 Web 的报告。
But again this isn't a reporting coursey there so we're not going to be getting into Crystal Reports and advanced Access reporting and all kinds of different web based reporting.

我们不打算讨论这些事情,因为这些事情真的太大了,太复杂了,它们本身就是单独的课程,如果你真的想擅长的话,已经有一些很棒的续集课程了。
We're not going to go into those things because really those are so big and so involved those really are separate courses all by themselves and there are already some great sequel courses out there if you really want to get good at that.

因此,在本课程中,我将教您如何将程序中的数据存储到数据库中,我们将学习如何将其拉回并查看它。
So in this course I'm going to teach you how to store data from your program into a database and we're going to learn how to pull it back up and look at it.

但我们真的不会更深入。
But we're really not going to go much deeper.

但这就是我们安装续集的原因。
But that's why we're installing sequel.

这就是我们目前要做的事情。
That's about as much as we're going to be doing with this for now.

稍后我们可能会进入这里并选择一些数据库,您知道如何检查记录和运行查询。
Later on we might be getting in here and picking at some databases and you know learning how to check the records and run queries.

但目前我们在这方面做得很好。
But for right now we're good on this.

我们的服务器已经运行了。
We've got our server running.

我们能够连接到它。
We're able to connect to it.

因此,当我们真正准备好进行数据采集时,它已经在线了几个部分。
So it's online several sections down the road when we get to the point where we're actually ready to get into data acquisition.

我们就准备出发了。
We'll be ready to go.

所以请看下一讲
So see in next lecture